How should i store availability calendar information in mysql? for [id] [date] [available/unavailab
Posted
by Haroldo
on Stack Overflow
See other posts from Stack Overflow
or by Haroldo
Published on 2010-04-16T14:56:25Z
Indexed on
2010/04/16
15:03 UTC
Read the original article
Hit count: 167
I'm building a simple calendar for holiday cottages to show when they are booked or available.
What would be the fastest mysql table design for this, bearing in mind when users mark dates as available/booked they will do so via a start date and an end date.
i can see 2 obvious options
- Store 'booked' data for every day [more rows]
- or, store 'booked' data with 2 columns a start_date and end_date [more processing?]
Which is best or is there another method i'm missing?
© Stack Overflow or respective owner